Skip to main content

Publica Network

Overview​

This document provides information about Publica Network.

-- Users that have accounts in more than 1 tenant
SELECT
 email,
 COUNT(*) repeated_accounts
FROM
 users
WHERE
 email IS NOT NULL
 AND email NOT LIKE '%publica.la%'
 AND email NOT LIKE '%ink-it.ink%'
 AND email NOT LIKE '%plaurino%'
 AND email NOT LIKE '%nfrette%'
 AND email NOT LIKE '%test.com%'
 AND email NOT LIKE '%hafsalmetvr%'
 AND email NOT LIKE '%lucas.nz.d%'
 AND email NOT LIKE '%prueba.com%'
 AND email NOT LIKE '%luismvaccaro%'
 AND email NOT LIKE '%sbotti%'
 AND email NOT IN('fkroup@gmail.com', 'carlosardila35@gmail.com', 'luchov10@hotmail.com', 'franco.gilio@gmail.com', 'dark_soul_d@yahoo.com', 'carlosardi_10@hotmail.com', 'actelesca@gmail.com', 'ron@headcanon.com', 'jesicamarroquinm@gmail.com', 'matiascarreraruetsch@gmail.com', 'julietgarcia9@gmail.com', 'camussisofia@gmail.com', 'tehsis@gmail.com', 'mafe.garzon05@gmail.com', 'micaternowyk@gmail.com', 'prueba@gmail.com')
GROUP BY
 email
HAVING
 repeated_accounts > 1
ORDER BY
 repeated_accounts DESC;
X

Graph View